SCM - Adithya-Prudvi - 2016-06-22 - 27496 - NA_PP_CONSUME_MTO Job runtime issue (Bhumi by 2016-06-29) #ProductionBreakFix #hold
2016-06-24 - 27496 - Service Request - NA_PP_CONSUME_MTO Job run time issue
Problem Summary
NA_PP_CONSUME_MTO Job run time issue
Admin Info
Purpose
|
NA_PP_CONSUME_MTO Job run time issue
|
Requested by
|
Bhumi Shah
|
Issue Date
|
06-22-2016
|
Resolved by
|
Prudvi, Adithya
|
Resolved Date
|
|
Document Status
|
WIP
|
Detailed Problem Description
(Include Screen Shots if required )
Find out logic behind program ZRPP_MCC_PLO_FCT_NEW and reason behind run time longer than 3 hours.
Solution Analysis and Recommendations
(Include Screen Shots if required)
As requested to find the logic behind the program "ZRPP_MCC_PLO_FCT_NEW" here is the logic for the program:
Here is the attached technical fields with the logic:
logic.docx.
ZRPP_MCC_PLO_FCT_NEW
1. A Variant "ZRPP_MTO_PLO_SOR" is maintained in TVARVC Table in which the sales order is maintained.
2. Value which is maintained in TVARVC (Sales Order) is passed in to VBAP Table to get entries:
a. Sales Order.
b. Sales Order item
c. Material
d. Plant
The above data "2" would be filtered by Season "CUS" and only those entries are considered.
3. Pass Sales Order numbers and its corresponding items in table VBEP and to get data:
a. Sales Oder
b. Sales Order item
c. Schedule line date
d. Delivery Schedule Line Number
e. Confirmed Quantity
In the Above "3" reject the data which is has schedule line date less than system date, and consider the entires which are greater than system date.
4. Pass Material Number "2C" in "Product group" feild, V in 'Prd. group type" feild & "2d" in Plant feilds in table PGMI.
If there are no entries in the table PGMI, the material which we given in the input of the program "Reference Material" is replaced with all the material data
VBAP (Data whihc is generated in 2nd Step).
5. Pass Replcaed material, Plant, in table PBIM, to get
a. Material
b. Plant
c. Independent requirements pointer
6. Pass Independent requirements pointer "5C" in to table PBED and get:
a. Independent requirements pointer
b. Planned quantity
c. Planning period
7. Pass Replaced Material and Plant "2d" in to Table PLAF to get:
a. Order finish date in the planned order
b. Material
c. Production plant in planned order
d. Total planned order quantity
e. Planned order number
Calculations:
Calculations : get week from date from table VBEP "2C" & PLAF "7a".
Convert date to Week by using FM - DATE_GET_WEEK
Recording (BDC) to change quantity in MD12:
8.
FIRST CHECK : Check entry in PBIM by passing Plant "2d", Replaced Material
If No Records are Found in Table - End of the Program.
If Entry Found
SECOND CHECK - Check entry in PBED by passing Planning period "6c" = "2c" (modified to Week) and Independent requirements pointer"5c"
If No Records are Found in Table - End of the Program.
If Entry Found
THIRD CHECK : Check entry in table PLAF by passing Planning period "6c", Plant "2d", Material "2c"
If Entry Found -
Total planned order quantity = Planned quantity "6b" - Confirmed Quantity "3e"
This quantity is updated in the
Check in table PLAF with Week"2c" (Modified to Week), Plant"2d" Modified Material, if there is a planned order entry then
Change the quantity in the planned order.
Resolution
This Program updates the quantity in the Planned orders.
As there are no entries in the table PBED, PBIM the program is not doing anything in NEP
Release Information
Provide link here to Release Notes if Technical Objects were changed